2016-05-18 - 27189 - Break Fix - Currency display for AR250 APAC #CrystalReportsSupport
BREAK FIX
27189 - AR250 report currency display issue
Problem Summary
Need to fix AR250 report currency display issue for Emerging APAC region only in BI Production.
Admin Info
| Purpose |
Need to fix AR250 report currency display issue for Emerging APAC region only in BI Production. |
| Requested by |
Poter Wong |
| Issue Date |
05-18-2016 |
| Resolved by |
Dhananjay G |
| Resolved Date |
06-02-2016 |
| Document Status |
Complete |
Detailed Problem Description
Email from Mark Harris on 05/18/2016:
Please help to correct below errors on BI Aging Analysis AR250:1. For New Zealand, the credit limit currency should be NZD not N/A.
2. For APAC, the company currency and the credit limit currency should be USD.
Solution Analysis and Recommendations
For NEC Hong Kong, APAC(‘0050’): the company code currency and credit limit currency are different at the source level. The company code currency is maintained as ‘HKD’ where as credit limit currency is "USD".
For remaining all the company codes, the company code currency and credit limit currency are same, so there is no issue with the other regional versions of the report.
1. The credit limit currency ’N/A’ in report group section can be fixed by replacing the repository function with credit limit currency.
Note: In Global version of the AR250 report, repository is updated with credit limit currency & hence there is no issue in the Global report.
2. Company code currency in the report header section is directly getting updated from the BEx query, as HKD is maintained as company code currency in BW, it is being shown in the report. If USD needs to be shown, then credit limit currency has to be updated there (or) we may need to create a formula to show the company code currency as "USD" by overwriting "HKD".
Test Plan
| Test ID |
Test Scenario |
Expected Results |
| 1 |
Report Format. |
Should be as per NEC crystal standard checklist. |
| 2 |
Execute Crystal Report in Crystal Designer tool after changes. |
Report should execute successfully in Crystal Designer tool. |
| 3 |
Schedule the Report in NEC BI Launch Pad. |
Report should execute successfully in NEC BI Launch Pad. |
Resolution
1. The credit limit currency ’N/A’ in report group section was fixed by replacing the repository function with credit limit currency formula.
2. Company code currency in the report header section is directly getting updated from the BEx query, as HKD is maintained as company code currency in BW, it is being shown in the report.
3. Placed the report in BI development and informed NEC for promotion after successful validation.
Release Information
2016-06-02 - 27189 - Rel Notes - Currency display for AR250 APAC